This document provides a sample report for automated insights into drivers and outcomes of crop prodution systems at landscape level as part of the LCAS system.

Initial overview

First, we need to load the datast of interest. Make sure it has been cleaned properly using the cleaning files.

We can then produce some key statistics to provide and overview of the dataset. The dataset contains data from the following countries: India, from the years 2017, 2018 for Rice. The average landholding size was 1.15 ha and the average size of the largest plot was 0.238 ha. Data has been collected in the following states/provinces: Bihar, UttarPradesh. The dataset contains 9,694 samples. And the following distribution of samples across the sample provinces/states:

## 
## Attaching package: 'knitr'
## The following object is masked from 'package:terra':
## 
##     spin
## 
## Attaching package: 'data.table'
## The following object is masked from 'package:terra':
## 
##     shift
State/Province % of samples
Bihar 73.66
UttarPradesh 26.34

Showing the sample locations

## The legacy packages maptools, rgdal, and rgeos, underpinning the sp package,
## which was just loaded, will retire in October 2023.
## Please refer to R-spatial evolution reports for details, especially
## https://r-spatial.org/r/2023/05/15/evolution4.html.
## It may be desirable to make the sf package available;
## package maintainers should consider adding sf to Suggests:.
## The sp package is now running under evolution status 2
##      (status 2 uses the sf package in place of rgdal)
## Linking to GEOS 3.11.0, GDAL 3.5.3, PROJ 9.1.0; sf_use_s2() is TRUE
## Warning: attribute variables are assumed to be spatially constant throughout
## all geometries

Yield and crop variety patterns

The average yield across the dataset is 4.09 t ha-1 with a standard deviation of 1.13 t ha-1.

The yield distribution looks as follows:

The mean yield and standard deviation per state/province in descending order:

State/Province Mean yield Standard Deviation
UttarPradesh 4.28 1.06
Bihar 4.02 1.15

The same table per variety looks as follows:

Variety Type Mean yield Standard Deviation
Improved 4.13 1.16
Hybrid 4.00 1.04
Basmati 3.34 1.12
Local 3.30 1.27

The most common varieites grown are the following:

TODO Need script for cleaning variety names, lower_case, no space etc.

Variety name % of samples
MTU_7029 0.25
Arize6444Gold 0.19
BPT5204 0.08
Sarju52 0.06
Moti 0.05

Management practices

On average, rice crops have been (trans)planted or directly sown on 12. of July and harvested on 14. of November with 3.95 irrigation events and a total of 57.69 kg urea and 1.02 kg npk applied per plot.

Add additional info including (do the report for rice, subset to Bihar+UP):